/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50635
 Source Host           : 127.0.0.1
 Source Database       : sheying

 Target Server Type    : MySQL
 Target Server Version : 50635
 File Encoding         : utf-8

 Date: 11/10/2017 17:57:25 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `course_comments`
-- ----------------------------
DROP TABLE IF EXISTS `course_comments`;
CREATE TABLE `course_comments` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `content` text,
  `course_id` int(10) DEFAULT NULL,
  `replay_user_id` int(10) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` int(10) DEFAULT NULL,
  `is_display` int(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `course_comments`
-- ----------------------------
BEGIN;
INSERT INTO `course_comments` VALUES ('1', null, '4', null, '2017-11-08 14:08:42', '2017-11-10 15:42:59', '1', '0'), ('2', '嘿嘿嘿', '4', null, '2017-11-08 14:10:20', '2017-11-10 15:43:04', '1', '0'), ('3', '@admin hahha', '4', null, '2017-11-08 14:35:21', '2017-11-10 15:43:08', '1', '0'), ('4', '说三道四多所多所多多所多', '4', null, '2017-11-08 14:40:07', '2017-11-08 14:40:07', '1', '1'), ('5', 'heihei', '4', '1', '2017-11-08 14:41:07', '2017-11-08 14:41:07', '1', '1');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
